package com.gugee.ins.common.dal.mapper.dic;

import com.gugee.common.mapper.GugeeMapper;
import com.gugee.ins.common.model.mysql.dic.InsDicCommercialCategory;
import org.apache.ibatis.annotations.Select;

import java.util.List;


/**
 * ins博主商业分类字典表
 * @author Huangxin
 */
public interface InsDicCommercialCategoryMapper extends GugeeMapper<InsDicCommercialCategory> {
    /**
     * 获取所有一级分类
     * @return
     */
    @Select("select commercial_category from ins_dic_commercial_category group by commercial_category ")
    List<String> findAllOverallCategory();

}
